Release 10.1A: OpenEdge Development:
Basic Database Tools


Modifying a trigger

Editing a table or field trigger modifies the database’s schema.

To modify a table trigger:

  1. Choose Schema Modify Table. The Data Dictionary alphabetically lists all the tables defined for your database.
  2. Select the table for which you want to modify the trigger. The Modify Table window appears.
  3. Choose Triggers. The Table Triggers dialog box appears.
  4. Select the trigger you want to modify.
  5. Press PUT to enter the trigger code. The Trigger Code dialog box appears.
  6. Edit the trigger code.
  7. Choose OK to return to the Table Triggers dialog box.
  8. Choose OK to return to the Modify Table window.

To modify a field trigger:

  1. Choose Schema Field Editor. The Field Editor alphabetically lists all the tables defined for your database.
  2. Select the table for which you want to modify the trigger. The Field Editor appears.
  3. Choose Triggers.
  4. Select the field for which you want to modify the trigger. The Field Triggers dialog box appears.
  5. Specify the name of the trigger procedure, then press PUT to enter the trigger code. The Trigger Code window appears.
  6. Edit the trigger code.
  7. Choose OK to return to the Field Triggers dialog box.
  8. Choose OK to return to the Field Editor.

Copyright © 2005 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095